Step 1: Question 6: Create a new database and tables Create a table Categories with columns CategoryID (integer, primary key) and CategoryName (text, not null). Create a table Products with columns ProductID (integer, primary key), ProductName (text, not null), and CategoryID (integer, foreign key referencing Categories table). Insert sample data into the tables Insert categories: Keyboards and Mice into the Categories table. Insert products: Mechanical Keyboard and Wireless Keyboard under the Keyboards category, and Gaming Mouse under the Mice category. Write DELETE statements to delete the Keyboards category Write a DELETE statement to delete all products in the Keyboards category. Write a DELETE statement to delete the Keyboards category from the Categories table. Answer: The first statement will delete all products in the "Keyboards" category, and the second statement will delete the category itself. Here is the SQL script: -- Create categories table CREATE TABLE categories ( category_id INTEGER PRIMARY KEY, category_name TEXT NOT NULL ); -- Create products table CREATE TABLE products ( product_id INTEGER PRIMARY KEY, product_name TEXT NOT NULL, category_id INTEGER, FOREIGN KEY (category_id) REFERENCES categories (category_id) ); -- Insert sample data into categories INSERT INTO categories (category_id, category_name) VALUES (1, 'Keyboards'); INSERT INTO categories (category_id, category_name) VALUES (2, 'Mice'); -- Insert sample data into products INSERT INTO products (product_id, product_name, category_id) VALUES (1, 'Mechanical Keyboard', 1); INSERT INTO products (product_id, product_name, category_id) VALUES (2, 'Wireless Keyboard', 1); INSERT INTO products (product_id, product_name, category_id) VALUES (3, 'Gaming Mouse', 2); -- Display data before DELETE operations SELECT * FROM categories; SELECT * FROM products; -- Delete products in the Keyboards category DELETE FROM products WHERE category_id = (SELECT category_id FROM categories WHERE category_name = 'Keyboards'); -- Delete the Keyboards category DELETE FROM categories WHERE category_name = 'Keyboards'; -- Display data after DELETE operations SELECT * FROM categories; SELECT * FROM products; <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA8EAAAM4CAYAAADs1eDRAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAP+lSURBVHhe7P0NeBTXmS/6/j2zMz62YhxAsgAR1GlzwSDsiDhGbBOsqyae8eAQKdrHijcOIb3vc+3E14Swd6wwN4N1ZGUmiuw9mODHHvueu9syMTsj7iatEDOebdM6MsGDIA6KQchwsNI4fFggQYzT9mHCjO96V63qrm519Zc+kNT/n5+yulZVV61aVd3UW++q6ms+VkBERERERESUB/7E/CUiIiIiIiKa9K45fOIMM8FERERERESUF1J2hz7yzll4Z95oxsip7+z7WHTzTDNGREREREREEwG7QxMREREREVHeYBBMREREREREeYNBMBEREREREeUNBsFERERERESUN/hgrBzxwVhERERENB68N3AJA+9HzNjoKLyxADMKp5ixzLFuudVt408uY/OuP4I/4zPUNWrYsOoTaP7atVZBDhgE54hBMBERERGNB3LOvtA7A39yjYQHI+/fVLhwtO+9nM59Wbfc6nbtV//AADgF2WOX/+GT1kgO2B2aiIiIiGiCG61ATgx32axb9hgApzbc9mEQTERERERERHnjT94O9+uuAMkGId1+3YaT/Zdw8YP/S89HRERERERENN6cu/ABnHHvNZf/5crHf/aJPzWTs/Mvf/xXnBl4H5/4E2DqDf+LKc0PchGA9wQTERER0dUmJ/WjfV6a6zpYt9zW8Wdf/YN5RW7+JcN7giUA/uhfrmDm9Cmw494/yTUAFvLeWYU34tKH/2JKiIiIiIhovPinf/oVWp74Bz3Ia6cXX3w1Oq27+4QpJTfSRoltSOPfhUsfxgXAYtj3BMvC/vXfMr01+Rj+6+Jvofze/4G3TQkREREREY08Cdh+1PJTHby9994FUxpPymX4z//l769qICx1kKD8P/+XZ8dlQC4XCqSNpD2ljjRxXPnXf4sLgMUkfjBWH7Y9sAn3/9dD+MCUEBERERHli9+89Q5mzJiK7S99H3/3X7+Fv/iLz5splq9//W5dXv/oV/V4f//v9d+xJsHv6gf+Fi+0/pMKgN8xpeOLBOnSluXlN7teUKCJYxIHwX/EuaMDeHvwihknIiIiIsovM2ZMM6/cZTLPaJEA+JV/OqCC8W/qIFOUl8/Vf8eTv/jzO1Twe1EH6eOxfmLDYwX6Ptm44b9dhw1m+oi59zqcc6zjrW+Zcu0T+Kf/5lh/4nTz3vj3jL2MguDRutox0P4Eyhd/C2u/9RS+UvUtlC/7z3iktQ+X9VS76/Tf4pFvfQ/L1evlX3kKT//qkp6K/v8Dj6iye/9bnzWOAfzsEdPV+tA/qOU+hW1S/I//Tb83Nh8RERER0eT32dtu1sFbJr6x9i9QXPwpMzY2JMaQ7K9kou3A8p57MqvvWJMs+vaX/t96sDPn49O/IfDVP+gHa/3ZV/+Itwv+FH/12CfMtJHx3Io/xaci/4rvqXUETgO3/N+vx3N6igTA16IK1jRdh//j39T0qx/0JkoZBMuB6VvxXfzmN6MbQP7mwyl48O++g4ZK4JdPPYG/2/dHM0U58x4uf+5/xYs/+3/hq1P78L//P/8aP3ROT+a2Wuzt+E/Qh+fdX8XLHX+Hn97v1ZOIiIiIiPKBBG6JXaDdSNfosc5wvr

Computer science

can i please have help with these. all one problem. thank you :)

Answer

Student’s rating for this solution:

★ ★ ★ ★ ★ (5/5)

YOU HAVE TO REGISTER FOR ANSWER

Computer science

Computer science

Manu

Answer

Extracted Transcript from Images